<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `fanwe_msg_template`;");
E_C("CREATE TABLE `fanwe_msg_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `type` tinyint(1) NOT NULL,
  `is_html` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8");
E_D("replace into `fanwe_msg_template` values('1','TPL_MAIL_COUPON','{\$coupon.user_name}你好! 你购买的{\$coupon.deal_name}已购买成功，团购券序列号{\$coupon.sn}密码{\$coupon.password},有效期为{\$coupon.begin_time_format}到{\$coupon.end_time_format}','1','0');");
E_D("replace into `fanwe_msg_template` values('2','TPL_SMS_COUPON','{\$coupon.user_name}你好! 你购买的{\$coupon.deal_sub_name}已购买成功，团购券序列号{\$coupon.sn}密码{\$coupon.password},有效期为{\$coupon.begin_time_format}到{\$coupon.end_time_format}','0','0');");
E_D("replace into `fanwe_msg_template` values('3','TPL_MAIL_USER_VERIFY','{\$user.user_name}你好，请点击以下链接验证你的会员身份\r\n</p>\r\n<a href=''{\$user.verify_url}''>{\$user.verify_url}</a>','1','1');");
E_D("replace into `fanwe_msg_template` values('4','TPL_MAIL_USER_PASSWORD','{\$user.user_name}你好，请点击以下链接修改您的密码\r\n</p>\r\n<a href=''{\$user.password_url}''>{\$user.password_url}</a>','1','1');");
E_D("replace into `fanwe_msg_template` values('5','TPL_SMS_PAYMENT','{\$payment_notice.user_name}你好,你所下订单{\$payment_notice.order_sn}的收款单{\$payment_notice.notice_sn}金额{\$payment_notice.money_format}于{\$payment_notice.pay_time_format}支付成功','0','0');");
E_D("replace into `fanwe_msg_template` values('6','TPL_MAIL_PAYMENT','{\$payment_notice.user_name}你好,你所下订单{\$payment_notice.order_sn}的收款单{\$payment_notice.notice_sn}金额{\$payment_notice.money_format}于{\$payment_notice.pay_time_format}支付成功','1','0');");
E_D("replace into `fanwe_msg_template` values('7','TPL_SMS_DELIVERY','{\$delivery_notice.user_name}你好,你所下订单{\$delivery_notice.order_sn}的商品{\$delivery_notice.deal_names}于{\$delivery_notice.delivery_time_format}发货成功,发货单号{\$delivery_notice.notice_sn}','0','0');");
E_D("replace into `fanwe_msg_template` values('8','TPL_MAIL_DELIVERY','{\$delivery_notice.user_name}你好,你所下订单{\$delivery_notice.order_sn}的商品{\$delivery_notice.deal_names}于{\$delivery_notice.delivery_time_format}发货成功,发货单号{\$delivery_notice.notice_sn}','1','0');");
E_D("replace into `fanwe_msg_template` values('9','TPL_SMS_VERIFY_CODE','你的手机号为{\$verify.mobile},验证码为{\$verify.code}','0','0');");
E_D("replace into `fanwe_msg_template` values('10','TPL_DEAL_NOTICE_SMS','{\$notice.site_name}又有新团购啦!{\$notice.deal_name},欢迎来抢团{\$notice.site_url}','0','0');");
E_D("replace into `fanwe_msg_template` values('11','TPL_MAIL_UNSUBSCRIBE','您好，您确定要退订{\$mail.mail_address}吗？要退订请点击<a href=\"{\$mail.url}\">完成退订</a>','1','1');");
E_D("replace into `fanwe_msg_template` values('12','TPL_SMS_USE_COUPON','{\$coupon.user_name}你好! 你购买的{\$coupon.deal_sub_name}，团购券{\$coupon.sn}，已于{\$coupon.confirm_time_format}使用','0','0');");
E_D("replace into `fanwe_msg_template` values('13','TPL_MAIL_USE_COUPON','{\$coupon.user_name}你好! 你购买的{\$coupon.deal_name}，团购券{\$coupon.sn}，已于{\$coupon.confirm_time_format}使用','1','0');");
E_D("replace into `fanwe_msg_template` values('14','TPL_SMS_LOTTERY','{\$lottery.user_name}你好! 你参加的{\$lottery.deal_sub_name}，抽奖号为{\$lottery.lottery_sn}','0','0');");
E_D("replace into `fanwe_msg_template` values('15','TPL_SMS_STORE_ORDER','{\$order.user_name}，{\$order.location_name}{\$order.order_time}订位成功。{\$order.info}，餐位保留15分钟。地址：{\$order.address}。[{\$order.tel}]','0','0');");
E_D("replace into `fanwe_msg_template` values('16','TPL_SMS_STORE_KTV_ORDER','{\$order.user_name}，{\$order.location_name}{\$order.order_time}预订成功。{\$order.info}，包箱保留15分钟。地址：{\$order.address}。[{\$order.tel}]','0','0');");

require("../../inc/footer.php");
?>